<template>
  <div class="app-container">
    <!-- 搜索 -->
    <div class="filter-container tw-filter">
      <el-button class="filter-item tw-filter-button" size="medium" icon="el-icon-edit" v-has="$store.state.user.btn_common+'add'" @click="handleAdd()">添加</el-button>
      <el-button class="filter-item tw-filter-button" size="medium" v-has="$store.state.user.btn_common+'edit'" @click="handleEditField()">更新表字段</el-button>
      <el-button class="filter-item tw-filter-button" size="medium" icon="el-icon-delete" v-has="$store.state.user.btn_common+'del'" @click="handleDelete()">批量删除</el-button>

      <el-input v-model="queryList.name" placeholder="请输入表名" class="filter-item tw-filter-input" clearable />
      <el-select v-model="queryList.state" class="filter-item tw-filter-input" placeholder="请选择状态">
        <el-option key="" label="全部状态" value="" />
        <el-option key="1" label="启用" value="1" />
        <el-option key="0" label="禁用" value="0" />
      </el-select>

      <el-button v-waves class="filter-item tw-filter-button" size="medium" icon="el-icon-search" @click="handleFilter">搜索</el-button>
    </div>

    <!-- 列表 -->
    <el-table
      v-loading="listLoading"
      :data="tableList"
      @selection-change="handleSelectionChange"
      border fit highlight-current-row style="width: 100%;"
    >
      <el-table-column type="selection" width="50" />
      <el-table-column label="表名" prop="name" align="left" />
      <el-table-column label="主键字段名" prop="key_name" align="left" />
      <el-table-column label="默认排序" prop="order" align="left" />
      <el-table-column label="排序字段" prop="sort_name" align="left" />
      <el-table-column label="状态字段" prop="state_name" align="left" />
      <el-table-column label="父级字段" prop="parent_name" align="left" />
      <el-table-column label="键操作开始值" prop="start_id" align="center" />
      <el-table-column label="表名注释" prop="annotation" align="left" />
      <el-table-column label="状态" align="center">
        <template slot-scope="{row}">
          <span v-if="row.state == 1" style="color:#090">启用</span>
          <span v-else>禁用</span>
        </template>
      </el-table-column>
      <el-table-column label="操作" align="center" width="160px" class-name="small-padding fixed-width">
        <template slot-scope="{row}">
          <el-button size="mini" v-has="$store.state.user.btn_common+'edit'" @click="handleEdit(row.id)">编辑</el-button>
          <el-button size="mini" v-has="$store.state.user.btn_common+'upshow'" v-if="row.state" @click="handleUpshow(row.id)">禁用</el-button>
          <el-button size="mini" v-has="$store.state.user.btn_common+'show'" v-else @click="handleShow(row.id)">启用</el-button>
          <el-button size="mini" v-has="$store.state.user.btn_common+'del'" @click="handleDelete(row.id)">删除</el-button>
        </template>
      </el-table-column>
    </el-table>
    <pagination v-show="isPage && listTotal > 0" :total="listTotal" :page.sync="queryList.curpage" :limit.sync="queryList.page" @pagination="getList" />

    <!-- 添加/编辑 -->
    <el-dialog width="40%" :title="textMap[dialogStatus]" :visible.sync="dialogFormVisible">
      <el-form label-position="right" label-width="120px" ref="dataForm" :rules="rules" :model="form">
        <el-form-item label="表名" prop="name">
          <el-input v-model="form.name" />
          <p class="tw-tip-text">不带表前缀</p>
        </el-form-item>
        <el-form-item label="主键字段名" prop="key_name">
          <el-input v-model="form.key_name" />
        </el-form-item>
        <el-form-item label="默认排序" prop="order">
          <el-input v-model="form.order" />
          <p class="tw-tip-text">默认排序字符串</p>
        </el-form-item>
        <el-form-item label="排序字段" prop="sort_name">
          <el-input placeholder="请输入排序字段" v-model="form.sort_name" />
        </el-form-item>
        <el-form-item label="状态字段" prop="state_name">
          <el-input placeholder="请输入状态字段" v-model="form.state_name" />
        </el-form-item>
        <el-form-item label="父级字段" prop="parent_name">
          <el-input placeholder="请输入父级字段" v-model="form.parent_name" />
        </el-form-item>
        <el-form-item label="键操作开始值" prop="start_id">
          <el-input v-model="form.start_id" />
          <p class="tw-tip-text">只可以操作键值大于多少的数据(整数)</p>
        </el-form-item>
        <el-form-item label="表名注释" prop="annotation">
          <el-input placeholder="请输入表名注释" v-model="form.annotation" />
        </el-form-item>
        <el-form-item label="状态">
          <el-radio-group v-model="form.state">
            <el-radio :label="1">启用</el-radio>
            <el-radio :label="0">禁用</el-radio>
          </el-radio-group>
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button @click="dialogStatus==='create'?createData():updateData()">保存</el-button>
        <el-button @click="dialogFormVisible = false">取消</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
import Pagination from '@/components/Pagination' // 基于el分页的二次封装
import waves from '@/directive/waves' // waves directive
import * as api from '@/api/project/databasetable';

export default {
  components: { Pagination },
  directives: { waves },
  data() {
    return {
      // 数据列表
      listLoading: true,
      listTotal: 0,
      isPage: false,
      tableList: [],
      multipleSelection: [],//多选数据
      // 添加/编辑弹窗
      dialogFormVisible: false,
      dialogStatus: '',
      textMap: {
      	update: '编辑',
      	create: '添加'
      },
      //键字段
      keyName: 'id',
      apiPath: 'project.databasetable',

      // 搜索数据
      queryList: {
      	page: this.$store.state.settings.page, // 每页显示数量
      	curpage: 1, // 当前页码
        name: '', //表名
        state: null // 状态，0禁用，1启用
      },

      // 表单数据
      form: {
        id: '',
        name: '', //表名
        key_name: '', //主键字段名
        order: '',  //默认排序
        sort_name:'', //排序字段
        state_name:'', //状态字段
        parent_name:'', //父级字段
        start_id: 0,  //主键开始操作值
        annotation:'',  //表名注释
        state: 1 //状态 0禁用 1启用
      },
      // 重置数据
      formReset: {
        id: '',
        name: '', //表名
        key_name: '', //主键字段名
        order: '',  //默认排序
        sort_name:'', //排序字段
        state_name:'', //状态字段
        parent_name:'', //父级字段
        start_id: 0,  //主键开始操作值
        annotation:'',  //表名注释
        state: 1 //状态 0禁用 1启用
      },
      // 验证
      rules: {
        name: [{ required: true, message: '请输入表名！', trigger: 'blur' }],
        key_name: [{ required: true, message: '请输入主键字段名！', trigger: 'blur' }],
      }
    }
  },
  created() {
    //获取数据列表
    this.getList();
  },
  methods: {
/*******************************公共方法******************************/
      // 搜索
      handleFilter() {
      	this.queryList.curpage = 1
      	this.tableList = []
        this.listTotal = 0
      	this.getList()
      },
      // 列表选择
      handleSelectionChange(val) {
      	this.multipleSelection = val
      },
      // 重置form
      resetForm() {
      	this.form = JSON.parse(JSON.stringify(this.formReset))
      },
			// 获取数据列表
			getList() {
				this.listLoading = true
				this.$api.fetchList(this.queryList, this.apiPath).then(response => {
					this.tableList = response.list
					this.listTotal = response.list_count
					this.isPage = response.is_page
          this.listLoading = false
				})
			},
			// 添加
			handleAdd() {
			  this.resetForm()
			  this.dialogStatus = 'create'
			  this.dialogFormVisible = true
			  this.$nextTick(() => {
			    this.$refs['dataForm'].clearValidate()
			  })
			},
			// 编辑
			handleEdit(id = 0) {
			  this.resetForm()
			  // 获取详情
			  this.$api.getDetail({ id: id }, this.apiPath).then(response => {
          //数据处理
          for(let key in this.form){
            if(response.detail.hasOwnProperty(key)){
              this.form[key] = response.detail[key]
            }
          }
			  })
			  this.dialogStatus = 'update'
			  this.dialogFormVisible = true
			  this.$nextTick(() => {
			    this.$refs['dataForm'].clearValidate();
			  })
			},
      // 添加-数据提交
      createData() {
        this.$refs['dataForm'].validate((valid) => {
          if (valid) {
            this.$api.add(this.form, this.apiPath).then(() => {
              // 重新获取列表
              this.queryList.curpage = 1
              this.tableList = []
              this.getList()

              this.dialogFormVisible = false
              this.$message({
                message: '添加成功',
                type: 'success'
              })
            })
          }
        })
      },
      // 编辑-数据提交
      updateData() {
        this.$refs['dataForm'].validate((valid) => {
          if (valid) {
            this.$api.edit(this.form, this.apiPath).then(response => {
              // 重新获取列表
              this.getList()

              this.dialogFormVisible = false
              this.$message({
                message: '编辑成功',
                type: 'success'
              })
            })
          }
        })
      },
      // 删除
      handleDelete(id = 0) {
        let current = this
        let id_str = ''
        if (!id) {
          // 多选
          if (!this.multipleSelection.length) {
            this.$message({
              message: '请选择删除的条目！',
              type: 'warning'
            })
            return false
          }
          // 数据处理
          this.multipleSelection.forEach(item => {
            id_str += item[current.keyName] + ','
          })
        } else {
          id_str = id
        }

        // 提交数据
        this.$confirm('确认删除数据吗?', '提示', {
          confirmButtonText: '确定',
          cancelButtonText: '取消',
          type: 'warning'
        }).then(() => {
          this.$api.del({ id_str: id_str }, this.apiPath).then(response => {
            // 重新获取列表
            this.getList()
            this.$message({
              message: '删除成功',
              type: 'success'
            })
          })
        })
      },
			//启用
			handleShow(id = 0) {
				this.$confirm('确认启用数据吗?', '提示', {
					confirmButtonText: '确定',
					cancelButtonText: '取消',
					type: 'warning'
				}).then(() => {
					this.$api.show({ id_str: id }, this.apiPath).then(response => {
						// 重新获取列表
						this.getList()
						this.$message({
							message: '启用成功',
							type: 'success'
						})
					})
				})
			},
			//禁用
			handleUpshow(id = 0) {
				this.$confirm('确认禁用数据吗?', '提示', {
					confirmButtonText: '确定',
					cancelButtonText: '取消',
					type: 'warning'
				}).then(() => {
					this.$api.upshow({ id_str: id }, this.apiPath).then(response => {
						// 重新获取列表
						this.getList()
						this.$message({
							message: '禁用成功',
							type: 'success'
						})
					})
				})
			},
/*******************************公共方法END******************************/
      //更新表字段
      handleEditField(){
        this.$api.otherPost({}, this.apiPath + '/editField').then(response => {
          this.$message({
            message: '更新成功',
            type: 'success'
          })
        })
      }

    }
  }
</script>
